IF exists(SELECT * FROM dbo.sysobjects WHERE name='leerlingen' AND xtype='V') 
BEGIN
	DROP VIEW leerlingen
END
GO

create view leerlingen
as
select * from leerlingen..leerlingen